<%@ page language="java" import="java.util.*,java.util.Date,java.sql.*,java.text.SimpleDateFormat"
	contentType="text/html; charset=utf-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<jsp:useBean id="db" class="connBean.ConnDB" scope="page" />

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<%=basePath%>">

		<title>欧米购商城</title>

		<meta http-equiv="pragma" content="no-cache">
		<meta http-equiv="cache-control" content="no-cache">
		<meta http-equiv="expires" content="0">
		<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
		<meta http-equiv="description" content="This is my page">


		<link rel="stylesheet" href="css/style.css" type="text/css"
			media="all" />
		<!--[if lte IE 6]><link rel="stylesheet" href="css/ie6.css" type="text/css" media="all" /><![endif]-->

		<meta name="keywwords"
			content="Shop Around - Great free html template for on-line shop. Use it as a start point for your on line business. The template can be easily implemented in many open source E-commerce platforms" />
		<meta name="description"
			content="Shop Around - Great free html template for on-line shop. Use it as a start point for your on line business. The template can be easily implemented in many open source E-commerce platforms" />

		<!-- JS -->
		<script src="js/jquery-1.4.1.min.js" type="text/javascript">
</script>
		<script src="js/jquery.jcarousel.pack.js" type="text/javascript">
</script>
		<script src="js/jquery-func.js" type="text/javascript">
</script>
		<!-- End JS -->

		<script>
$(function() {
	var t = $("#text_box");
	$("#add").click(function() {
		t.val(parseInt(t.val()) + 1)
		setTotal();
	})
	$("#min").click(function() {
		t.val(parseInt(t.val()) - 1)
		setTotal();
	})
	function setTotal() {
		$("#total").html((parseInt(t.val()) * 3.95).toFixed(2));
	}
	setTotal();
})
</script>


		<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

	</head>
	<body>
		<style>
#content {
	float: left;
	width: 724px;
}

#sidebar {
	float: right;
	width: 226px;
}

.search {
	min-height: 700px;
}

.search-addcart {
	width: 100px;
	background: url(images/cart-link.png) no-repeat 0 0;
	border: 0;
	color: #fff;
	height: 27px;
	display: block;
	line-height: 26px;
	cursor: pointer;
	margin: 12px 0 10px 0;
}

#slider {
	height: 700px;
	position: relative;
	overflow: hidden;
	list-style-type: none;
	border: 0
}

#slider-holder {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
	border: 0
}

#slider-holder .jcarousel-clip {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
}

#slider-holder ul {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
	list-style-type: none;
}

#slider-holder ul li {
	width: 231px;
	height: 383px;
	position: relative;
	overflow: hidden;
	float: left;
}

#slider-nav {
	position: absolute;
	top: 350px;
	left: 120px;
	z-index: 2;
}

#slider-nav a {
	font-size: 0;
	line-height: 0;
	text-indent: -4000px;
	width: 10px;
	height: 10px;
	border: solid 1px #8b0000;
	background: #8b0000;
	float: right;
	margin-right: 5px;
}

#slider-nav a:hover,#slider-nav a.active {
	background: #fff;
}

.datas {
	
}

.datas ul {
	list-style-type: none;
}

.datas ul li {
	position: relative;
	padding: 1px;
	border: solid 1px #dedede;
	float: left;
	width: 231px;
	margin-right: 9px;
	height: 383px;
	overflow: hidden;
}

.datas ul li2 {
	position: relative;
	padding: 1px;
	border: solid 1px #dedede;
	float: left;
	width: 465px;
	margin-right: 9px;
	height: 383px;
	overflow: hidden;
}

.datas ul li.last {
	margin-right: 0;
}
</style>
		<%
			request.setCharacterEncoding("UTF-8");
			SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格
  String date=df.format(new Date());// new Date()为获取当前系统时间
		%>
		<jsp:include page="customerService.jsp"></jsp:include>
		<!-- Shell -->
		<div class="shell">

			<!-- Header -->
			<div id="header">
				<h1 id="logo">
					<a href="index.jsp">欧米购</a>
				</h1>
				<!-- Cart -->
				<div id="cart" align="center">
					<%
						if (session.getAttribute("username") == null
								|| session.getAttribute("username") == "") {
					%>您好，您还未登录！
					<div class="cl">
						&nbsp;
					</div>
					<a href="login.jsp" class="c2-link">[登录]</a>
					<a href="addUser.jsp" class="c2-link">[免费注册]</a>
					<%
						} else {
					%>欢迎您，<%=session.getAttribute("username")%>
					<a href="logout.jsp" class="c2-link">[退出]</a>
					<div class="cl">
						&nbsp;
					</div>
					<a href="personalData.jsp" class="c2-link">我的欧米购</a>
					<a href="shoppingCart.jsp" class="cart-link">我的购物车</a>
					<%
						}
					%>
				</div>
				<!-- End Cart -->

				<!-- Navigation -->
				<div id="navigation">
					<ul>
						<li>
							<a href="index.jsp">主页</a>
						</li>
						<%
							db.OpenConn();
							db.createStmt();
							String sql = "select * from main_type";
							ResultSet rs = db.Query(sql);
							while (rs.next()) {
						%>
						<li>
							<a href="index_main_Type.jsp?maintype_id=<%=rs.getInt("t_id")%>"><%=rs.getString("t_name")%></a>
						</li>
						<%
							}
							db.closeStmt();
							db.closeConn();
						%>
					</ul>
				</div>
				<!-- End Navigation -->
			</div>
			<!-- End Header -->

			<!-- Main -->
			<div id="main">
				<!-- End Content Slider -->

				<div id="sidebar">

					<!-- Search -->
					<div class="box search">
						<h2>
							其他商品
							<span></span>
						</h2>
						<div class="box-content">

						</div>
					</div>
					<!-- End Search -->

				</div>
				<!-- End Sidebar -->


				<!-- Content -->
				<div id="content">
					<%String p_id=request.getParameter("p_id");
					  int quantity=Integer.parseInt(request.getParameter("quantity"));
					  float price=Float.valueOf(request.getParameter("finalprice"));
					  if(session.getAttribute("username")==""||session.getAttribute("username")==null){
					      %>您还未登录，请进行<a href="login.jsp">登录</a>！<%
					  }else{
					      if(quantity==0){out.print("数量不能为0,3秒后返回");response.setHeader("Refresh","3;URL=index_ProductDetail.jsp?p_id="+p_id);}else{
					      db.OpenConn();
					      db.createStmt();
					      int c_id=0;
					      String csql="select * from customer where c_name='"+session.getAttribute("username")+"'";
					      ResultSet customers=db.Query(csql);
					      if(customers.next()) {c_id=customers.getInt("c_id"); }
					      String insertsql="insert into shoppingcart(c_id,p_id,p_price,p_number,p_lastTime) values("+c_id+",'"+p_id+"',"+price+","+quantity+",'"+date+"')";
					      int result=db.Update(insertsql);
					      if(result!=0){
					          out.print("添加成功！3秒后返回");
					          response.setHeader("Refresh","3;URL=index_ProductDetail.jsp?p_id="+p_id);
					      }
					      else{
					          out.print("添加失败！该商品已在购物车内！3秒后返回");
					          response.setHeader("Refresh","3;URL=index_ProductDetail.jsp?p_id="+p_id);
					      }
					  }
					 }
					 %>
				</div>
				<!-- End Content -->

			</div>
			<!-- End Main -->

			<!-- Side Full -->
			<div class="side-full">

				<!-- Text Cols -->
				<div class="cols">
					<div class="cl">
						&nbsp;
					</div>
					<div class="col">
						<h3 class="ico ico1">
							Donec imperdiet
						</h3>
						<p>
							Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec
							imperdiet, metus ac cursus auctor, arcu felis ornare dui.
						</p>
						<p class="more">
							<a href="#" class="bul">Lorem ipsum</a>
						</p>
					</div>
					<div class="col">
						<h3 class="ico ico2">
							Donec imperdiet
						</h3>
						<p>
							Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec
							imperdiet, metus ac cursus auctor, arcu felis ornare dui.
						</p>
						<p class="more">
							<a href="#" class="bul">Lorem ipsum</a>
						</p>
					</div>
					<div class="col">
						<h3 class="ico ico3">
							Donec imperdiet
						</h3>
						<p>
							Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec
							imperdiet, metus ac cursus auctor, arcu felis ornare dui.
						</p>
						<p class="more">
							<a href="#" class="bul">Lorem ipsum</a>
						</p>
					</div>
					<div class="col col-last">
						<h3 class="ico ico4">
							Donec imperdiet
						</h3>
						<p>
							Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec
							imperdiet, metus ac cursus auctor, arcu felis ornare dui.
						</p>
						<p class="more">
							<a href="#" class="bul">Lorem ipsum</a>
						</p>
					</div>
					<div class="cl">
						&nbsp;
					</div>
				</div>
				<!-- End Text Cols -->

			</div>
			<!-- End Side Full -->

			<!-- Footer -->
			<div id="footer">
				<p class="left">
					<a href="index.jsp">Home</a>
					<span>|</span>
					<a href="#">Support</a>
					<span>|</span>
					<a href="#">My Account</a>
					<span>|</span>
					<a href="#">The Store</a>
					<span>|</span>
					<a href="#">Contact</a>
				</p>
				<p class="right">
					&copy; 2015 OMEGO Shopping Design by &nbsp;
					<a href="#" target="_blank"
						title="The Sweetest CSS Templates WorldWide">欧米购创意小组</a>
				</p>
			</div>
			<!-- End Footer -->

		</div>
		<!-- End Shell -->


	</body>
</html>
